Type
Choose the index type: Nonclustered, Clustered, XML or Spatial
Unique
A unique index is one in which no two rows are permitted to have the same index key value.
Table/View
Choose to create a table index or a view index.
Table Name or View Name
Select a table or a view.
Fields
Select the column or columns on which the index is based ans the sorting order.